﻿CREATE TABLE [dbo].[Item]
(
	[ItemId] INT NOT NULL PRIMARY KEY IDENTITY, 
    [ItemName] NVARCHAR(50) NOT NULL, 
    [CategoryId] INT NOT NULL, 
    CONSTRAINT [FK_Item_Cateogry] FOREIGN KEY ([CategoryId]) REFERENCES [Category]([CategoryId])
)

GO

CREATE INDEX [IX_Item_CategoryId] ON [dbo].[Item] ([CategoryId])
